CREATE TABLE [dbo].[CartTop](
	[Id_CartTop] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
 CONSTRAINT [PK_CARTTOP] PRIMARY KEY CLUSTERED 
(
	[Id_CartTop] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[Biolim_Typ]    Script Date: 10/18/2012 12:45:19 ******/

CREATE TABLE [dbo].[Biolim_Typ](
	[Id_BioclTyp] [int] IDENTITY(0,1) NOT NULL,
	[ID_Niveau] [int] NULL,
	[Cod_BioclTyp] [char](50) NULL,
	[Cod1_BioclTyp] [char](10) NULL,
	[Cod2_BioclTyp] [char](10) NULL,
	[Niv_BioclTyp] [numeric](1, 0) NULL,
	[Nom_BioclTyp] [char](90) NULL,
	[Expl_BioclTyp] [varchar](90) NULL,
 CONSTRAINT [PK_BIOLIM_TYP] PRIMARY KEY CLUSTERED 
(
	[Id_BioclTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[BETAILTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[BETAILTYP](
	[Id_Betail] [int] IDENTITY(0,1) NOT NULL,
	[CODE_BETAIL] [char](6) NULL,
	[NOM_BETAIL] [char](40) NULL,
	[EXPL_BETAIL] [varchar](90) NULL,
 CONSTRAINT [PK_BETAILTYP] PRIMARY KEY CLUSTERED 
(
	[Id_Betail] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[BenfTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[BenfTyp](
	[ID_TypBenf] [int] IDENTITY(0,1) NOT NULL,
	[Cod_TypBenf] [char](9) NULL,
	[Nom_TypBenf] [char](30) NULL,
	[Expl_TypBenf] [char](99) NULL,
 CONSTRAINT [PK_BENFTYP] PRIMARY KEY CLUSTERED 
(
	[ID_TypBenf] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[BATIHUMTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[BATIHUMTYP](
	[Id_TypBati] [int] IDENTITY(0,1) NOT NULL,
	[CODE_TYPBATI] [char](9) NULL,
	[NOM_TYPBATI] [char](30) NULL,
	[EXPL_TYPBATI] [char](99) NULL,
 CONSTRAINT [PK_BATIHUMTYP] PRIMARY KEY CLUSTERED 
(
	[Id_TypBati] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ADRESSES]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ADRESSES](
	[ID_Adr] [int] IDENTITY(0,1) NOT NULL,
	[Id_CsrnTyp] [int] NOT NULL,
	[NUM_ADR] [numeric](18, 0) NULL,
	[ADRES_ADR__] [varchar](99) NULL,
	[TEL_ADR__] [char](20) NULL,
	[FAX_ADR__] [char](20) NULL,
	[VALID_ADR__] [date] NULL,
	[BP_ADR] [char](5) NULL,
	[CP_ADR] [char](7) NULL,
	[NOTE_ADR__] [varchar](90) NULL,
	[SW_CRNAP] [char](50) NULL,
 CONSTRAINT [PK_ADRESSES] PRIMARY KEY CLUSTERED 
(
	[ID_Adr] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ActvCateg]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ActvCateg](
	[Id_ActvCateg] [int] IDENTITY(0,1) NOT NULL,
	[Cod_EquipCateg] [char](6) NULL,
	[Nom_ActvCateg] [varchar](90) NULL,
	[Exp_ActvCateg] [varchar](90) NULL,
 CONSTRAINT [PK_ACTVCATEG] PRIMARY KEY CLUSTERED 
(
	[Id_ActvCateg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ACTNSGEST]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ACTNSGEST](
	[Id_ActGst] [int] IDENTITY(0,1) NOT NULL,
	[Id_PrgGst] [int] NULL,
	[ActIntit_ActGst] [char](99) NULL,
	[MesGst_ActGst] [varchar](90) NULL,
	[Amngts_ActGst] [binary](1) NULL,
	[ObjSpec_ActGst] [varchar](90) NULL,
	[CiblCmp_ActGst] [char](99) NULL,
	[CiblPop_ActGst] [varchar](90) NULL,
	[CiblEsp_ActGst] [varchar](90) NULL,
	[ActGst_ActGst] [varchar](90) NULL,
	[ActExe_ActGst] [varchar](90) NULL,
	[Meth_ActGst] [varchar](90) NULL,
	[Demar_ActGst] [date] NULL,
	[Echnce_ActGst] [date] NULL,
	[Cout_ActGst] [numeric](7, 0) NULL,
 CONSTRAINT [PK_ACTNSGEST] PRIMARY KEY CLUSTERED 
(
	[Id_ActGst] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ACTIVPATRIM]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ACTIVPATRIM](
	[Id_ValPat] [int] IDENTITY(0,1) NOT NULL,
	[Id_Activ] [int] NULL,
	[CARACT_VALPAT__DISTRIB_VALPAT__] [varchar](90) NULL,
	[DISTRIB_VALPAT] [varchar](90) NULL,
 CONSTRAINT [PK_ACTIVPATRIM] PRIMARY KEY CLUSTERED 
(
	[Id_ValPat] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ActivHumTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ActivHumTyp](
	[Id_TypActivHum] [int] IDENTITY(0,1) NOT NULL,
	[Id_ActvCateg] [int] NOT NULL,
	[Cod_TypActivHum] [char](9) NULL,
	[Nom_TypActivHum] [char](30) NULL,
	[Expl_TypActivHum] [char](99) NULL,
 CONSTRAINT [PK_ACTIVHUMTYP] PRIMARY KEY CLUSTERED 
(
	[Id_TypActivHum] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ACTIVHUMSIT]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ACTIVHUMSIT](
	[Id_Activ] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[Id_EspTyp] [int] NULL,
	[Id_TypActivHum] [int] NOT NULL,
	[InOut_Activ] [char](10) NULL,
	[Loc_Activ] [varchar](90) NULL,
	[DescImp_Activ] [varchar](90) NULL,
	[ExpImp_Activ] [varchar](90) NULL,
	[Note_Activ] [char](256) NULL,
	[SIGID] [varchar](20) NULL,
 CONSTRAINT [PK_ACTIVHUMSIT] PRIMARY KEY CLUSTERED 
(
	[Id_Activ] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ACTIVELEVAGE]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ACTIVELEVAGE](
	[Id_ExElev] [int] IDENTITY(0,1) NOT NULL,
	[Id_Activ] [int] NOT NULL,
	[Id_Betail] [int] NOT NULL,
	[DATE_EXELEV] [date] NULL,
	[TETES_EXELEV] [varchar](90) NULL,
	[MODE_EXELEV] [char](40) NULL,
	[NOTES_EXELEV] [numeric](3, 0) NULL,
 CONSTRAINT [PK_ACTIVELEVAGE] PRIMARY KEY CLUSTERED 
(
	[Id_ExElev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ACTIVBENEFSIT]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[ACTIVBENEFSIT](
	[Id_BnfAct] [int] IDENTITY(0,1) NOT NULL,
	[ID_TypBenf] [int] NOT NULL,
	[Id_Activ] [int] NOT NULL,
	[Id_Pop] [int] NOT NULL,
	[RVNBNF_BNFACT] [numeric](7, 0) NULL,
	[ECHTN_BNFACT] [numeric](3, 1) NULL,
	[DATED_BNFACT] [date] NULL,
	[DATEF_BNFACT] [date] NULL,
 CONSTRAINT [PK_ACTIVBENEFSIT] PRIMARY KEY CLUSTERED 
(
	[Id_BnfAct] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ACTIVAGRIC]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ACTIVAGRIC](
	[Id_ExAgr] [int] IDENTITY(0,1) NOT NULL,
	[Id_AgrTyp] [int] NOT NULL,
	[Id_Activ] [int] NOT NULL,
	[TAILLE_EXAGR] [numeric](8, 0) NULL,
	[EXPLMOD_EXAGR] [varchar](90) NULL,
	[IRRMOD_EXAGR] [varchar](90) NULL,
	[IRRQTTE_EXAGR] [numeric](3, 0) NULL,
	[FRTQTTE_EXAGR] [varchar](90) NULL,
	[FRTTYP_EXAGR] [numeric](18, 0) NULL,
	[SNTTYP_EXAGR] [varchar](90) NULL,
	[SNTQTTE_EXAGR] [numeric](3, 0) NULL,
 CONSTRAINT [PK_ACTIVAGRIC] PRIMARY KEY CLUSTERED 
(
	[Id_ExAgr] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ZONAGETYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ZONAGETYP](
	[Id__ZonTyp] [int] IDENTITY(0,1) NOT NULL,
	[Code_ZonTyp] [char](2) NULL,
	[Nom_ZonTyp] [char](30) NULL,
	[Expl_ZonTyp] [varchar](90) NULL,
 CONSTRAINT [PK_ZONAGETYP] PRIMARY KEY CLUSTERED 
(
	[Id__ZonTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ZONAGESIT]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ZONAGESIT](
	[Id_Zon] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NOT NULL,
	[Id__ZonTyp] [int] NOT NULL,
	[SectZon_Zon] [char](50) NULL,
	[CritChx_Zon] [varchar](90) NULL,
 CONSTRAINT [PK_ZONAGESIT] PRIMARY KEY CLUSTERED 
(
	[Id_Zon] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[VgtPatrim]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[VgtPatrim](
	[Id_VgPatrim] [int] IDENTITY(0,1) NOT NULL,
	[Id_VgtD] [int] NULL,
	[Expl_VgPatrim] [char](99) NULL,
	[Cons_VgPatrim] [varchar](90) NULL,
	[Act_VgPatrim] [varchar](90) NULL,
	[Prv_VgPatrim] [varchar](90) NULL,
 CONSTRAINT [PK_VGTPATRIM] PRIMARY KEY CLUSTERED 
(
	[Id_VgPatrim] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[VEGETNTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[VEGETNTYP](
	[Id_Vgt] [int] IDENTITY(0,1) NOT NULL,
	[ID_TypVgtRar] [int] NULL,
	[Id_TypVgtEnd] [int] NULL,
	[ID_Niveau] [int] NULL,
	[CODE_VGT] [char](15) NULL,
	[COD1_VGT] [char](3) NULL,
	[COD2_VGT] [char](3) NULL,
	[COD3_VGT] [char](3) NULL,
	[COD4_VGT] [char](3) NULL,
	[COD5_VGT] [char](3) NULL,
	[NIV_VGT] [numeric](1, 0) NULL,
	[NOM_VGT] [char](50) NULL,
	[EXPL_VGT] [varchar](90) NULL,
 CONSTRAINT [PK_VEGETNTYP] PRIMARY KEY CLUSTERED 
(
	[Id_Vgt] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[VEGETNGLO]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[VEGETNGLO](
	[Id_VgtG] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[Dom_VgtG] [numeric](3, 0) NULL,
	[Expl_VgtG] [varchar](90) NULL,
 CONSTRAINT [PK_VEGETNGLO] PRIMARY KEY CLUSTERED 
(
	[Id_VgtG] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[VEGETNDET]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[VEGETNDET](
	[Id_VgtD] [int] IDENTITY(0,1) NOT NULL,
	[Id_VgtG] [int] NULL,
	[Id_Vgt] [int] NOT NULL,
	[Loc_VgtD] [numeric](3, 0) NULL,
	[Expl_VgtD] [varchar](90) NULL,
 CONSTRAINT [PK_VEGETNDET] PRIMARY KEY CLUSTERED 
(
	[Id_VgtD] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[VALHUMSITE]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[VALHUMSITE](
	[Id_ValH] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[Id_ValTyp] [int] NOT NULL,
	[NOMVA] [char](50) NULL,
	[LOC_VALH] [char](99) NULL,
	[EXPL_VALH] [char](99) NULL,
	[CONSETT_VALH] [char](255) NULL,
	[ACTCONS_VALH] [char](255) NULL,
	[PRVCONS_VALH] [char](255) NULL,
 CONSTRAINT [PK_VALHUMSITE] PRIMARY KEY CLUSTERED 
(
	[Id_ValH] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[VALEURSTYPOL]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[VALEURSTYPOL](
	[Id_ValTyp] [int] IDENTITY(0,1) NOT NULL,
	[ID_Niveau] [int] NULL,
	[Code_ValTyp] [char](6) NULL,
	[Code01_ValTyp] [char](2) NULL,
	[Code02_ValTyp] [char](2) NULL,
	[Code03_ValTyp] [char](2) NULL,
	[Niv_ValTyp] [numeric](1, 0) NULL,
	[NOM_VALTYP] [char](50) NULL,
	[EXPL_VALTYP] [char](255) NULL,
 CONSTRAINT [PK_VALEURSTYPOL] PRIMARY KEY CLUSTERED 
(
	[Id_ValTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]





/****** Object:  Table [dbo].[TypVgtRar]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[TypVgtRar](
	[ID_TypVgtRar] [int] IDENTITY(0,1) NOT NULL,
	[Cod_TypVgtRar] [char](2) NULL,
	[Nom_TypVgtRar] [char](256) NULL,
	[Expl_TypVgtRar] [char](99) NULL,
 CONSTRAINT [PK_TYPVGTRAR] PRIMARY KEY CLUSTERED 
(
	[ID_TypVgtRar] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[TypVgtEnd]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[TypVgtEnd](
	[Id_TypVgtEnd] [int] IDENTITY(0,1) NOT NULL,
	[CODE_ENDTYP5] [char](2) NULL,
	[Nom_TypVgtEnd] [char](50) NULL,
	[Expl_TypVgtEnd] [varchar](90) NULL,
 CONSTRAINT [PK_TYPVGTEND] PRIMARY KEY CLUSTERED 
(
	[Id_TypVgtEnd] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[TypTopog]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[TypTopog](
	[Id_TypTopog] [int] IDENTITY(0,1) NOT NULL,
	[Cod_TypTopog] [char](50) NULL,
	[Nom_TypTopog] [char](50) NULL,
	[Expl_TypTopog] [char](99) NULL,
 CONSTRAINT [PK_TYPTOPOG] PRIMARY KEY CLUSTERED 
(
	[Id_TypTopog] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


/****** Object:  Table [dbo].[TYPPROTCTN]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[TYPPROTCTN](
	[Id_Tprot] [int] IDENTITY(0,1) NOT NULL,
	[CodProt_Tprot3] [char](5) NULL,
	[Nom_Tprot] [char](50) NULL,
	[Desc_Tprot] [varchar](90) NULL,
 CONSTRAINT [PK_TYPPROTCTN] PRIMARY KEY CLUSTERED 
(
	[Id_Tprot] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[TypPAG]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[TypPAG](
	[Id_TypPAG] [int] IDENTITY(0,1) NOT NULL,
	[CODPROT_TPROT] [char](5) NULL,
	[NOMPROT_TPROT] [char](50) NULL,
	[DESCPROT_TPROT] [varchar](90) NULL,
 CONSTRAINT [PK_TYPPAG] PRIMARY KEY CLUSTERED 
(
	[Id_TypPAG] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[TypHabitRar]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[TypHabitRar](
	[Id_TypHabitRar] [int] IDENTITY(0,1) NOT NULL,
	[Cod_TypHabitRar] [char](2) NULL,
	[Expl_TypHabitRar] [char](99) NULL,
	[Nom_TypHabitRar] [char](50) NULL,
 CONSTRAINT [PK_TYPHABITRAR] PRIMARY KEY CLUSTERED 
(
	[Id_TypHabitRar] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[TypHabitEnd]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[TypHabitEnd](
	[Id_TypHabitEnd] [int] IDENTITY(0,1) NOT NULL,
	[CODE_ENDTYP] [char](2) NULL,
	[Nom_TypHabitEnd] [char](50) NULL,
	[Expl_TypHabitEnd] [varchar](90) NULL,
 CONSTRAINT [PK_TYPHABITEND] PRIMARY KEY CLUSTERED 
(
	[Id_TypHabitEnd] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[TYPFONCIER]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[TYPFONCIER](
	[Id_TypFonc] [int] IDENTITY(0,1) NOT NULL,
	[CodFon_TypFonc] [char](5) NULL,
	[NomFon_TypFonc] [char](50) NULL,
	[DescFon_TypFonc] [char](99) NULL,
 CONSTRAINT [PK_TYPFONCIER] PRIMARY KEY CLUSTERED 
(
	[Id_TypFonc] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[Topog]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[Topog](
	[Id_Topog] [int] IDENTITY(0,1) NOT NULL,
	[Id_TypTopog] [int] NOT NULL,
	[Id_Ord] [int] NULL,
	[Unit_Topog] [char](50) NULL,
	[Suprf_Topog] [numeric](18, 0) NULL,
 CONSTRAINT [PK_TOPOG] PRIMARY KEY CLUSTERED 
(
	[Id_Topog] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[SUIVIPOPSIT]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[SUIVIPOPSIT](
	[Id_SPop] [int] IDENTITY(0,1) NOT NULL,
	[Id_Pop] [int] NOT NULL,
	[Id_hht] [int] NULL,
	[Id_TypBati] [int] NULL,
	[DATREC_SPOP] [date] NULL,
	[EFFECTIF_SPOP] [numeric](8, 0) NULL,
	[MENNB_SPOP] [numeric](7, 0) NULL,
	[MENTAL_SPOP] [numeric](4, 2) NULL,
 CONSTRAINT [PK_SUIVIPOPSIT] PRIMARY KEY CLUSTERED 
(
	[Id_SPop] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[SttPhenTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[SttPhenTyp](
	[Id_SttPhenTyp] [int] IDENTITY(0,1) NOT NULL,
	[CodeStat_SttPhenTyp] [char](4) NULL,
	[Nom_SttPhenTyp] [char](50) NULL,
	[ExplStat_SttPhenTyp] [char](99) NULL,
 CONSTRAINT [PK_STTPHENTYP] PRIMARY KEY CLUSTERED 
(
	[Id_SttPhenTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[STRUCTINSTR]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[STRUCTINSTR](
	[Id_SNI] [int] IDENTITY(0,1) NOT NULL,
	[Id_Pop] [int] NOT NULL,
	[Id_NivIns] [int] NOT NULL,
	[Id_ClAge] [int] NOT NULL,
	[DATREC_SNI] [date] NULL,
	[MENNB_SNI] [numeric](4, 0) NULL,
	[MALE_SNI] [numeric](7, 0) NULL,
 CONSTRAINT [PK_STRUCTINSTR] PRIMARY KEY CLUSTERED 
(
	[Id_SNI] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[STRUCTDEMO]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[STRUCTDEMO](
	[Id_SAge] [int] IDENTITY(0,1) NOT NULL,
	[Id_Pop] [int] NOT NULL,
	[Id_ClAge] [int] NOT NULL,
	[DATREC_SAGE] [date] NULL,
	[CLASNB_SAGE] [numeric](4, 0) NULL,
	[Male_SAge] [numeric](7, 0) NULL,
 CONSTRAINT [PK_STRUCTDEMO] PRIMARY KEY CLUSTERED 
(
	[Id_SAge] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[STRUCTACTIV]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[STRUCTACTIV](
	[Id_SAct] [int] IDENTITY(0,1) NOT NULL,
	[Id_Pop] [int] NOT NULL,
	[Id_ClAge] [int] NOT NULL,
	[DATREC_SACT] [date] NULL,
	[ACTIFSNB_SACT] [numeric](4, 0) NULL,
	[Male_SAct] [numeric](18, 0) NULL,
 CONSTRAINT [PK_STRUCTACTIV] PRIMARY KEY CLUSTERED 
(
	[Id_SAct] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[STRGEOLTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[STRGEOLTYP](
	[Id_StrG] [int] IDENTITY(0,1) NOT NULL,
	[ID_Niveau] [int] NULL,
	[Code_StrG] [char](15) NULL,
	[Cod1_StrG] [char](3) NULL,
	[Cod2_StrG] [char](3) NULL,
	[Cod3_StrG] [char](3) NULL,
	[Cod4_StrG] [char](3) NULL,
	[Cod5_StrG] [char](3) NULL,
	[Niv_StrG] [numeric](1, 0) NULL,
	[Nom_StrG] [char](50) NULL,
	[Expl_StrG] [varchar](90) NULL,
 CONSTRAINT [PK_STRGEOLTYP] PRIMARY KEY CLUSTERED 
(
	[Id_StrG] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[STATMETEO]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[STATMETEO](
	[Id_Met] [int] IDENTITY(0,1) NOT NULL,
	[Id_CsrnTyp] [int] NOT NULL,
	[Id_BioclTyp] [int] NOT NULL,
	[NomStat_Met] [varchar](90) NULL,
	[GesStat_Met] [char](30) NULL,
	[DatDbt_Met] [date] NULL,
	[DatFin_Met] [date] NULL,
	[Longit_Met] [char](5) NULL,
	[Latit_Met] [char](5) NULL,
	[Altit_Met] [char](4) NULL,
	[LOCTXT_MET] [varchar](90) NULL,
 CONSTRAINT [PK_STATMETEO] PRIMARY KEY CLUSTERED 
(
	[Id_Met] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[Stade_Typ]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[Stade_Typ](
	[Id_StdTyp] [int] IDENTITY(0,1) NOT NULL,
	[Code_StdTyp] [numeric](18, 0) NULL,
	[Nom_StdTyp] [char](90) NULL,
	[Exp_StdTyp] [varchar](90) NULL,
 CONSTRAINT [PK_STADE_TYP] PRIMARY KEY CLUSTERED 
(
	[Id_StdTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[SOURCESTYP]    Script Date: 10/18/2012 12:45:19 ******/


CREATE TABLE [dbo].[SOURCESTYP](
	[Id_SceTyp] [int] IDENTITY(0,1) NOT NULL,
	[Code_SceTyp] [char](2) NULL,
	[Nom_SceTyp] [char](50) NULL,
	[EXPL_SCETYP] [varchar](90) NULL,
 CONSTRAINT [PK_SOURCESTYP] PRIMARY KEY CLUSTERED 
(
	[Id_SceTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[SourcesRef]    Script Date: 10/18/2012 12:45:19 ******/


CREATE TABLE [dbo].[SourcesRef](
	[Id_Ref] [int] IDENTITY(0,1) NOT NULL,
	[Id_TypVgtEnd] [int] NULL,
	[Id_TypBati] [int] NULL,
	[Id_HydrTyp] [int] NULL,
	[Id_hht] [int] NULL,
	[Id_EndTyp] [int] NULL,
	[ID_TypVgtRar] [int] NULL,
	[Id_TypHabitEnd] [int] NULL,
	[Id_SedimTyp] [int] NULL,
	[Id_TypHabitRar] [int] NULL,
	[Id_DiagT] [int] NULL,
	[Id_BioclTyp] [int] NULL,
	[Id_NivIns] [int] NULL,
	[Id_ClAge] [int] NULL,
	[Id_rgl] [int] NULL,
	[Id_SceTyp] [int] NOT NULL,
	[Id_RarOrgTypol] [int] NULL,
	[Id_HabTypl] [int] NULL,
	[Id_RochesTyp] [int] NULL,
	[Id_TypTopog] [int] NULL,
	[Id_StrG] [int] NULL,
	[Id_ValTyp] [int] NULL,
	[Id_Rel] [int] NULL,
	[Id_Vgt] [int] NULL,
	[Id_HydroGeolTyp] [int] NULL,
	[NumSce_Ref] [numeric](18, 0) NULL,
	[AutSce_Ref] [varchar](90) NULL,
	[AnnSce_Ref] [numeric](4, 0) NULL,
	[TitSce_Ref] [varchar](90) NULL,
	[RefSce_Ref] [varchar](90) NULL,
	[NotSce_Ref] [varchar](90) NULL,
	[AdrSce_Ref] [varchar](90) NULL,
 CONSTRAINT [PK_SOURCESREF] PRIMARY KEY CLUSTERED 
(
	[Id_Ref] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]





/****** Object:  Table [dbo].[SITESTFONCIER]    Script Date: 10/18/2012 12:45:19 ******/
CREATE TABLE [dbo].[SITESTFONCIER](
	[Id_Fonc] [int] IDENTITY(0,1) NOT NULL,
	[Id_TypFonc] [int] NOT NULL,
	[ID_Sit] [int] NULL,
	[LOCFON_FONC] [varchar](90) NULL,
	[SRFFON_FONC] [numeric](5, 0) NULL,
	[NOTES_FONC] [varchar](90) NULL,
	[SIGID] [varchar](20) NULL,
 CONSTRAINT [PK_SITESTFONCIER] PRIMARY KEY CLUSTERED 
(
	[Id_Fonc] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[SiteStatus]    Script Date: 10/18/2012 12:45:19 ******/

CREATE TABLE [dbo].[SiteStatus](
	[Id_Tprot] [int] NOT NULL,
	[DatDec_Sit] [date] NULL,
	[DatDeb_Sit] [date] NULL,
	[MtfAfct_Sit] [varchar](90) NULL,
	[DatFin_Sit] [date] NULL,
	[MtfFin_Sit] [varchar](90) NULL,
	[CODESTATUS] [char](10) NULL,
	[DATEMODST_SIT] [date] NULL,
 CONSTRAINT [PK_SITESTATUS] PRIMARY KEY CLUSTERED 
(
	[Id_Tprot] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


/****** Object:  Table [dbo].[SedimTyp]    Script Date: 10/18/2012 12:45:19 ******/

CREATE TABLE [dbo].[SedimTyp](
	[Id_SedimTyp] [int] IDENTITY(0,1) NOT NULL,
	[Code_SedimTyp] [char](15) NULL,
	[Nom_SedimTyp] [char](50) NULL,
	[Expl_SedimTyp] [varchar](90) NULL,
 CONSTRAINT [PK_SEDIMTYP] PRIMARY KEY CLUSTERED 
(
	[Id_SedimTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[SedimSitlFrn]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[SedimSitlFrn](
	[Id_SedimSitlFrn] [int] IDENTITY(0,1) NOT NULL,
	[Id_SedimTyp] [int] NOT NULL,
	[Id_SedimSit] [int] NULL,
	[Unit_SedimSitlFrn] [varchar](50) NULL,
	[Suprf_SedimSitlFrn] [numeric](18, 0) NULL,
	[Desc_SedimSitlFrn] [varchar](90) NULL,
 CONSTRAINT [PK_SEDIMSITLFRN] PRIMARY KEY CLUSTERED 
(
	[Id_SedimSitlFrn] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[SedimSit]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[SedimSit](
	[Id_SedimSit] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[FrmDom_SedimSit] [varchar](90) NULL,
	[CarFrm_SedimSit] [varchar](90) NULL,
	[ExplFrm_SedimSit] [varchar](90) NULL,
 CONSTRAINT [PK_SEDIMSIT] PRIMARY KEY CLUSTERED 
(
	[Id_SedimSit] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[RochesTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[RochesTyp](
	[Id_RochesTyp] [int] IDENTITY(0,1) NOT NULL,
	[ID_Niveau] [int] NULL,
	[Code_RochesTyp] [char](15) NULL,
	[Cod1_RochesTyp] [char](3) NULL,
	[Cod2_RochesTyp] [char](3) NULL,
	[Cod3_RochesTyp] [char](3) NULL,
	[Cod4_RochesTyp] [char](3) NULL,
	[Cod5_RochesTyp] [char](3) NULL,
	[Niv_RochesTyp] [numeric](1, 0) NULL,
	[Nom_RochesTyp] [char](50) NULL,
	[Expl_RochesTyp] [varchar](90) NULL,
 CONSTRAINT [PK_ROCHESTYP] PRIMARY KEY CLUSTERED 
(
	[Id_RochesTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[RGLTTNTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[RGLTTNTYP](
	[ID_RegTyp] [int] IDENTITY(0,1) NOT NULL,
	[Id_ReglCateg] [int] NOT NULL,
	[COD_REG_TYP] [char](2) NULL,
	[NOM_REGTYP] [char](50) NULL,
	[EXPL_REGTYP] [varchar](90) NULL,
 CONSTRAINT [PK_RGLTTNTYP] PRIMARY KEY CLUSTERED 
(
	[ID_RegTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[RGLTTN]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[RGLTTN](
	[Id_rgl] [int] IDENTITY(0,1) NOT NULL,
	[ID_RegTyp] [int] NOT NULL,
	[COD_RGL] [char](3) NULL,
	[NOM_RGL] [char](50) NULL,
	[DATDEC_RGL] [date] NULL,
	[DATAPP_RGL] [date] NULL,
	[NOTES_RGL] [char](99) NULL,
	[Chem_rgl] [char](90) NULL,
 CONSTRAINT [PK_RGLTTN] PRIMARY KEY CLUSTERED 
(
	[Id_rgl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[RevsionReg]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[RevsionReg](
	[Id_Rev] [int] IDENTITY(0,1) NOT NULL,
	[Id_rgl] [int] NOT NULL,
	[Date_Rev] [date] NULL,
 CONSTRAINT [PK_REVSIONREG] PRIMARY KEY CLUSTERED 
(
	[Id_Rev] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[REGLEMENTEPAR]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[REGLEMENTEPAR](
	[ID_Sit] [int] NOT NULL,
	[Id_rgl] [int] NOT NULL,
	[DATA_REGLT] [date] NULL,
 CONSTRAINT [PK_REGLEMENTEPAR] PRIMARY KEY CLUSTERED 
(
	[ID_Sit] ASC,
	[Id_rgl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[ReglCateg]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ReglCateg](
	[Id_ReglCateg] [int] IDENTITY(0,1) NOT NULL,
	[Cod_ReglCateg] [char](6) NOT NULL,
	[Nom_ReglCateg] [varchar](90) NULL,
	[Exp_ReglCateg] [varchar](90) NULL,
 CONSTRAINT [PK_REGLCATEG] PRIMARY KEY CLUSTERED 
(
	[Id_ReglCateg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[Region]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[Region](
	[Id_Reg] [int] IDENTITY(0,1) NOT NULL,
	[SIGID] [varchar](20) NULL,
 CONSTRAINT [PK_REGION] PRIMARY KEY CLUSTERED 
(
	[Id_Reg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[REFERENCEDANS]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[REFERENCEDANS](
	[ID_Sit] [int] NOT NULL,
	[Id_Ref] [int] NOT NULL,
	[DATA_REFERENCE] [date] NULL,
 CONSTRAINT [PK_REFERENCEDANS] PRIMARY KEY CLUSTERED 
(
	[ID_Sit] ASC,
	[Id_Ref] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[RarStatTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[RarStatTyp](
	[ID_RarTyp] [int] IDENTITY(0,1) NOT NULL,
	[Id_RarOrgTypol] [int] NOT NULL,
	[Cod_RarTyp] [char](2) NULL,
	[Nom_RarTyp] [char](50) NULL,
	[Expl_RarTyp] [char](99) NULL,
 CONSTRAINT [PK_RARSTATTYP] PRIMARY KEY CLUSTERED 
(
	[ID_RarTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[RARORGTYPOL]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[RARORGTYPOL](
	[Id_RarOrgTypol] [int] IDENTITY(0,1) NOT NULL,
	[COD_RARTPL] [char](2) NULL,
	[Nom_RarOrgTypol] [char](50) NULL,
	[ABREV_RARTPL] [char](10) NULL,
	[SWEB_RARTPL] [char](99) NULL,
 CONSTRAINT [PK_RARORGTYPOL] PRIMARY KEY CLUSTERED 
(
	[Id_RarOrgTypol] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[PROGGEST]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[PROGGEST](
	[Id_PrgGst] [int] IDENTITY(0,1) NOT NULL,
	[Id_PlnGst] [int] NULL,
	[PROGRAM_PRGGST] [char](99) NULL,
	[OBJESTIFS_PRGGST] [varchar](90) NULL,
	[ECHNCE_PRGGST] [date] NULL,
	[COUT_PRGGST] [numeric](7, 0) NULL,
	[Obj_PrgGst] [varchar](90) NULL,
	[Exp_PrgGst] [varchar](90) NULL,
 CONSTRAINT [PK_PROGGEST] PRIMARY KEY CLUSTERED 
(
	[Id_PrgGst] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[PLANAMGEST]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[PLANAMGEST](
	[Id_PlnGst] [int] IDENTITY(0,1) NOT NULL,
	[Id_Ref] [int] NOT NULL,
	[Id_TypPAG] [int] NOT NULL,
	[ID_Sit] [int] NULL,
	[NOM_PlnGst] [char](99) NULL,
	[CADRE_PLNGST] [char](9) NULL,
	[FINCMT_PlnGst] [char](50) NULL,
	[DATADAT_PlnGst] [date] NULL,
	[MOVRGE_PlnGst] [char](99) NULL,
	[MOVRE_PlnGst] [char](99) NULL,
	[AUT_PlnGst] [char](99) NULL,
	[ESPGEO_PlnGst] [char](99) NULL,
	[OBJ_PlnGst] [varchar](90) NULL,
	[ORG_PlnGst] [varchar](90) NULL,
 CONSTRAINT [PK_PLANAMGEST] PRIMARY KEY CLUSTERED 
(
	[Id_PlnGst] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[PHENSTTTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[PHENSTTTYP](
	[Id_PhnTyp] [int] IDENTITY(0,1) NOT NULL,
	[COD_PHNTYP] [char](2) NULL,
	[NOM_PHNTYP] [char](50) NULL,
	[EXPL_PHNTYP] [varchar](90) NULL,
 CONSTRAINT [PK_PHENSTTTYP] PRIMARY KEY CLUSTERED 
(
	[Id_PhnTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]





/****** Object:  Table [dbo].[OROGRA_SIT]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[OROGRA_SIT](
	[Id_Ord] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[Reliefs_Ord] [varchar](90) NULL,
	[AltDom_Ord] [varchar](90) NULL,
 CONSTRAINT [PK_OROGRA_SIT] PRIMARY KEY CLUSTERED 
(
	[Id_Ord] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[NIVINSTRTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[NIVINSTRTYP](
	[Id_NivIns] [int] IDENTITY(0,1) NOT NULL,
	[CODE_NIVINS] [numeric](1, 0) NULL,
	[NOM_NIVINS] [char](30) NULL,
	[EXPL_NIVINS] [char](99) NULL,
 CONSTRAINT [PK_NIVINSTRTYP] PRIMARY KEY CLUSTERED 
(
	[Id_NivIns] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[Niveau]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[Niveau](
	[ID_Niveau] [int] IDENTITY(0,1) NOT NULL,
	[Niv_Niveau] [int] NULL,
	[Table_Niveau] [char](60) NULL,
	[Libelle_Niveau] [varchar](1) NULL,
 CONSTRAINT [PK_NIVEAU] PRIMARY KEY CLUSTERED 
(
	[ID_Niveau] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[LOCALITESITE]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[LOCALITESITE](
	[Id_Pop] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[LOCNOM_POP] [char](40) NULL,
	[LATMOY_POP] [numeric](7, 3) NULL,
	[LONMOY_POP] [numeric](7, 3) NULL,
	[ALTMOY_POP] [numeric](4, 0) NULL,
	[SIGID] [varchar](20) NULL,
 CONSTRAINT [PK_LOCALITESITE] PRIMARY KEY CLUSTERED 
(
	[Id_Pop] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[INFRAEQUIPTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[INFRAEQUIPTYP](
	[Id_TypEq] [int] IDENTITY(0,1) NOT NULL,
	[Id_EquipCateg] [int] NOT NULL,
	[ID_Niveau] [int] NULL,
	[CODE_TYPEQ] [char](9) NULL,
	[COD1_TYPEQ] [char](3) NULL,
	[COD2_TYPEQ] [char](3) NULL,
	[COD3_TYPEQ] [char](3) NULL,
	[Niv_TypEq] [numeric](18, 0) NULL,
	[NOM_TYPEQ] [char](30) NULL,
	[EXPLIC_TYPEQ] [char](99) NULL,
 CONSTRAINT [PK_INFRAEQUIPTYP] PRIMARY KEY CLUSTERED 
(
	[Id_TypEq] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HydrTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HydrTyp](
	[Id_HydrTyp] [int] IDENTITY(0,1) NOT NULL,
	[Code_HydrTyp] [char](15) NULL,
	[Nom_HydrTyp] [char](50) NULL,
	[Expl_HydrTyp] [varchar](90) NULL,
 CONSTRAINT [PK_HYDRTYP] PRIMARY KEY CLUSTERED 
(
	[Id_HydrTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HydrSitFrn]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HydrSitFrn](
	[Id_HydrSitFrn] [int] IDENTITY(0,1) NOT NULL,
	[Id_HydrSit] [int] NULL,
	[Id_HydrTyp] [int] NOT NULL,
	[Unit_HydrSitFrn] [varchar](30) NULL,
	[Suprf_HydrSitFrn] [numeric](18, 0) NULL,
	[Imputs_HydrSitFrn] [varchar](90) NULL,
	[Outputs_HydrSitFrn] [varchar](90) NULL,
	[Rithm_HydrSitFrn] [varchar](90) NULL,
	[Note_HydrSitFrn] [varchar](90) NULL,
 CONSTRAINT [PK_HYDRSITFRN] PRIMARY KEY CLUSTERED 
(
	[Id_HydrSitFrn] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HydrSit]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HydrSit](
	[Id_HydrSit] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[FrmDom_HydrSit] [varchar](90) NULL,
	[CarFrm_HydrSit] [varchar](90) NULL,
	[ExplFrm_HydrSit] [varchar](90) NULL,
 CONSTRAINT [PK_HYDRSIT] PRIMARY KEY CLUSTERED 
(
	[Id_HydrSit] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HydroGeolTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HydroGeolTyp](
	[Id_HydroGeolTyp] [int] IDENTITY(0,1) NOT NULL,
	[ID_Niveau] [int] NULL,
	[Code_HydroGeolTyp] [char](15) NULL,
	[Cod1_HydroGeolTyp] [char](3) NULL,
	[Cod2_HydroGeolTyp] [char](3) NULL,
	[Cod3_HydroGeolTyp] [char](3) NULL,
	[Cod4_HydroGeolTyp] [char](3) NULL,
	[Cod5_HydroGeolTyp] [char](3) NULL,
	[Niv_HydroGeolTyp] [numeric](1, 0) NULL,
	[Nom_HydroGeolTyp] [char](50) NULL,
	[Expl_HydroGeolTyp] [varchar](90) NULL,
 CONSTRAINT [PK_HYDROGEOLTYP] PRIMARY KEY CLUSTERED 
(
	[Id_HydroGeolTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HYDROGEOLSIT]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HYDROGEOLSIT](
	[Id_HydroGeolSit] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[ExplFrm_HydroGeolSit] [varchar](90) NULL,
 CONSTRAINT [PK_HYDROGEOLSIT] PRIMARY KEY CLUSTERED 
(
	[Id_HydroGeolSit] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HydroGeolFrn]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HydroGeolFrn](
	[Id_HydroGeolFrn] [int] IDENTITY(0,1) NOT NULL,
	[Id_HydroGeolTyp] [int] NOT NULL,
	[Id_HydroGeolSit] [int] NULL,
	[Loc_HydroGeolFrn] [char](150) NULL,
	[Expl_HydroGeolFrn] [char](150) NULL,
 CONSTRAINT [PK_HYDROGEOLFRN] PRIMARY KEY CLUSTERED 
(
	[Id_HydroGeolFrn] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]




/****** Object:  Table [dbo].[HABTYPOLS]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HABTYPOLS](
	[Id_HabTypl] [int] IDENTITY(0,1) NOT NULL,
	[CODE_HABTYPL] [char](2) NULL,
	[NOM_HABTYPL] [char](30) NULL,
	[EXPL_HABTYPL] [varchar](90) NULL,
	[REF_HABTYPL] [char](6) NULL,
 CONSTRAINT [PK_HABTYPOLS] PRIMARY KEY CLUSTERED 
(
	[Id_HabTypl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HABPATRIM]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HABPATRIM](
	[Id_HabPatr] [int] IDENTITY(0,1) NOT NULL,
	[Id_HabD] [int] NULL,
	[EXPLVAL_HABPATR] [char](99) NULL,
	[CONSVAL_HABPATR] [varchar](90) NULL,
	[ACTCONS_HABPATR] [varchar](90) NULL,
	[PRVCONS_HABPATR] [varchar](90) NULL,
 CONSTRAINT [PK_HABPATRIM] PRIMARY KEY CLUSTERED 
(
	[Id_HabPatr] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HABITATSTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HABITATSTYP](
	[Id_Hab] [int] IDENTITY(0,1) NOT NULL,
	[Id_TypHabitEnd] [int] NULL,
	[Id_HabTypl] [int] NOT NULL,
	[Id_TypHabitRar] [int] NULL,
	[ID_Niveau] [int] NULL,
	[CODE_HAB] [char](15) NULL,
	[COD1_HAB] [char](3) NULL,
	[COD2_HAB] [char](3) NULL,
	[COD3_HAB] [char](3) NULL,
	[COD4_HAB] [char](3) NULL,
	[COD5_HAB] [char](3) NULL,
	[NIV_HAB] [numeric](1, 0) NULL,
	[NOM_HAB] [char](50) NULL,
	[EXPL_HAB] [varchar](90) NULL,
 CONSTRAINT [PK_HABITATSTYP] PRIMARY KEY CLUSTERED 
(
	[Id_Hab] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HABITATSGLO]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HABITATSGLO](
	[Id_HabG] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[DOMHAB_HABG] [numeric](3, 0) NULL,
	[EXPLHAB_HABG] [varchar](90) NULL,
 CONSTRAINT [PK_HABITATSGLO] PRIMARY KEY CLUSTERED 
(
	[Id_HabG] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HABITATSDET]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HABITATSDET](
	[Id_HabD] [int] IDENTITY(0,1) NOT NULL,
	[Id_HabG] [int] NULL,
	[Id_Hab] [int] NOT NULL,
	[Loc_HabD] [numeric](3, 0) NULL,
	[Expl_HabD] [varchar](90) NULL,
 CONSTRAINT [PK_HABITATSDET] PRIMARY KEY CLUSTERED 
(
	[Id_HabD] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[HABHUMTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[HABHUMTYP](
	[Id_hht] [int] IDENTITY(0,1) NOT NULL,
	[CODHAB_HHT] [char](2) NULL,
	[NOMHAB_HHT] [char](30) NULL,
	[EXPLHAB_HHT] [char](99) NULL,
 CONSTRAINT [PK_HABHUMTYP] PRIMARY KEY CLUSTERED 
(
	[Id_hht] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[GroupeAuteur]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[GroupeAuteur](
	[Id_Obs] [int] NOT NULL,
	[Id_Rel] [int] NOT NULL,
 CONSTRAINT [PK_GROUPEAUTEUR] PRIMARY KEY CLUSTERED 
(
	[Id_Obs] ASC,
	[Id_Rel] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[GESTIONDELEGUE]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[GESTIONDELEGUE](
	[ID_Sit] [int] IDENTITY(0,1) NOT NULL,
	[Id_rgl] [int] NOT NULL,
	[CLAUSES_GESTDLG] [varchar](90) NULL,
	[CONTRAT_GESTDLG] [varchar](90) NULL,
	[DATDEB_GESTDLG] [date] NULL,
	[DATDEL_GESTDLG] [date] NULL,
	[DATFIN_GESTDLG] [date] NULL,
	[DATRESIL_GESTDLG] [date] NULL,
	[DROITS_GESTDLG] [numeric](18, 0) NULL,
	[NOTES_GESTDLG] [varchar](90) NULL,
 CONSTRAINT [PK_GESTIONDELEGUE] PRIMARY KEY CLUSTERED 
(
	[ID_Sit] ASC,
	[Id_rgl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[GeolStr]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[GeolStr](
	[Id_GeolStr] [int] IDENTITY(0,1) NOT NULL,
	[Id_StrG] [int] NOT NULL,
	[Id_GeoGl] [int] NULL,
	[Code_GeolStr] [int] NULL,
	[Loc_GeolStr] [numeric](18, 0) NULL,
	[Expl_GeolStr] [numeric](18, 0) NULL,
 CONSTRAINT [PK_GEOLSTR] PRIMARY KEY CLUSTERED 
(
	[Id_GeolStr] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[GeolRoches]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[GeolRoches](
	[ID_GeolRoch] [int] IDENTITY(0,1) NOT NULL,
	[Id_GeoGl] [int] NULL,
	[Id_RochesTyp] [int] NOT NULL,
	[Code_GeolRoch] [int] NULL,
	[Loc_GeolRoch] [numeric](18, 0) NULL,
	[Expl_GeolRoch] [numeric](18, 0) NULL,
	[SIGID] [varchar](20) NULL,
 CONSTRAINT [PK_GEOLROCHES] PRIMARY KEY CLUSTERED 
(
	[ID_GeolRoch] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[GEOLGEOMSIT]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[GEOLGEOMSIT](
	[Id_GeoGl] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[CARROC_GEOGL] [varchar](90) NULL,
	[CARSTRU_GEOGL] [varchar](90) NULL,
	[EXPLROC_GEOGL] [varchar](90) NULL,
 CONSTRAINT [PK_GEOLGEOMSIT] PRIMARY KEY CLUSTERED 
(
	[Id_GeoGl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FLOFAUSYST]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FLOFAUSYST](
	[Id_FloFauSyst] [int] IDENTITY(0,1) NOT NULL,
	[ID_RarTyp] [int] NULL,
	[Id_EndTyp] [int] NULL,
	[Id_Dsc] [int] NOT NULL,
	[CodTax_FloFauSyst] [char](15) NULL,
	[Regne_FloFauSyst] [char](3) NULL,
	[Phylum_FloFauSyst] [char](3) NULL,
	[Classe_FloFauSyst] [char](3) NULL,
	[Ordre_FloFauSyst] [char](3) NULL,
	[Famille_FloFauSyst] [char](3) NULL,
	[Genre_FloFauSyst] [char](3) NULL,
	[Espece_FloFauSyst] [char](3) NULL,
	[SubSpec_FloFauSyst] [char](3) NULL,
	[NivSys_FloFauSyst] [char](1) NULL,
	[NomSci_FloFauSyst] [char](25) NULL,
	[AutTax_FloFauSyst] [char](99) NULL,
	[CmbTax_FloFauSyst] [char](1) NULL,
	[Anne_FloFauSyst] [numeric](4, 0) NULL,
	[SIGID] [varchar](20) NULL,
 CONSTRAINT [PK_FLOFAUSYST] PRIMARY KEY CLUSTERED 
(
	[Id_FloFauSyst] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FLOFAUSIT]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FLOFAUSIT](
	[ID_FFS] [int] IDENTITY(0,1) NOT NULL,
	[Id_FloFauSyst] [int] NULL,
	[ID_Eco] [int] NULL,
	[Id_FloFauPatrim] [int] NULL,
	[CODE_FFS] [int] NULL,
	[ABOND_FFS] [char](50) NULL,
	[EXPLVAL_FFS] [char](99) NULL,
 CONSTRAINT [PK_FLOFAUSIT] PRIMARY KEY CLUSTERED 
(
	[ID_FFS] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FloFauRelTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FloFauRelTyp](
	[Id_RTyp] [int] IDENTITY(0,1) NOT NULL,
	[CodTyp_RTyp] [char](10) NULL,
	[NomTyp_RTyp] [char](50) NULL,
	[DscTyp_RTyp] [char](99) NULL,
 CONSTRAINT [PK_FLOFAURELTYP] PRIMARY KEY CLUSTERED 
(
	[Id_RTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FloFauRelev]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FloFauRelev](
	[Id_Rel] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[Id_RTyp] [int] NOT NULL,
	[Date_Rel] [date] NULL,
	[HreDbt_Rel] [date] NULL,
	[HreFin_Rel] [date] NULL,
	[Srfce_Rel] [numeric](18, 0) NULL,
	[Meteo_Rel] [char](99) NULL,
	[SaisS_Rel] [date] NULL,
	[SaisA_Rel] [char](50) NULL,
	[Note_Rel] [char](90) NULL,
 CONSTRAINT [PK_FLOFAURELEV] PRIMARY KEY CLUSTERED 
(
	[Id_Rel] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]




/****** Object:  Table [dbo].[FloFauRelEsp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FloFauRelEsp](
	[Id_REsp] [int] IDENTITY(0,1) NOT NULL,
	[Id_Rel] [int] NULL,
	[Id_FloFauSyst] [int] NULL,
	[Id_StdTyp] [int] NULL,
	[Stade_REsp] [char](90) NULL,
	[Abond_REsp] [char](256) NULL,
	[Note_REsp] [char](256) NULL,
 CONSTRAINT [PK_FLOFAURELESP] PRIMARY KEY CLUSTERED 
(
	[Id_REsp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FloFauPatrim]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FloFauPatrim](
	[Id_FloFauPatrim] [int] IDENTITY(0,1) NOT NULL,
	[Expl_FloFauPatr] [char](99) NULL,
	[Cons_FloFauPatr] [varchar](90) NULL,
	[Act_FloFauPatr] [varchar](90) NULL,
	[PrvFloFauPatr] [varchar](90) NULL,
 CONSTRAINT [PK_FLOFAUPATRIM] PRIMARY KEY CLUSTERED 
(
	[Id_FloFauPatrim] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FLOFAULANG]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FLOFAULANG](
	[Id_Lan] [int] IDENTITY(0,1) NOT NULL,
	[Id_FloFauSyst] [int] NULL,
	[CODE_LAN] [int] NULL,
	[NOMENG_LAN] [char](30) NULL,
	[NOMFRAN_LAN] [char](30) NULL,
	[NOMARB_LAN] [char](30) NULL,
	[NOMDIAL_LAN] [char](30) NULL,
 CONSTRAINT [PK_FLOFAULANG] PRIMARY KEY CLUSTERED 
(
	[Id_Lan] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FLOFAUECOL]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FLOFAUECOL](
	[ID_Eco] [int] IDENTITY(0,1) NOT NULL,
	[FREQ_ECO] [char](30) NULL,
 CONSTRAINT [PK_FLOFAUECOL] PRIMARY KEY CLUSTERED 
(
	[ID_Eco] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FloFauDsc]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FloFauDsc](
	[Id_Dsc] [int] IDENTITY(0,1) NOT NULL,
	[CarMorph_Dsc] [varchar](90) NULL,
	[CarReprod_Dsc] [varchar](90) NULL,
	[Repart_Dsc] [varchar](90) NULL,
 CONSTRAINT [PK_FLOFAUDSC] PRIMARY KEY CLUSTERED 
(
	[Id_Dsc] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FloFauAuteur]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FloFauAuteur](
	[Id_Obs] [int] IDENTITY(0,1) NOT NULL,
	[Code_Obs] [char](12) NULL,
	[Nom_Obs] [char](30) NULL,
	[Pren_Obs] [char](30) NULL,
	[Qual_Obs] [char](10) NULL,
	[Note_Obs] [char](90) NULL,
 CONSTRAINT [PK_FLOFAUAUTEUR] PRIMARY KEY CLUSTERED 
(
	[Id_Obs] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FlauPhenMa_FloFauSys]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[FlauPhenMa_FloFauSys](
	[Id_SttPhenTyp] [int] NOT NULL,
	[Id_FloFauSyst] [int] NOT NULL,
	[DebMoi_MgrSys] [numeric](18, 0) NULL,
	[DebSem_MgrSys] [numeric](18, 0) NULL,
	[FinMoi_MgrSys] [numeric](18, 0) NULL,
	[FinSem_MgrSys] [numeric](18, 0) NULL,
	[Expl_MgrSys] [varchar](90) NULL,
 CONSTRAINT [PK_FLAUPHENMA_FLOFAUSYS] PRIMARY KEY CLUSTERED 
(
	[Id_SttPhenTyp] ASC,
	[Id_FloFauSyst] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[FauPhenol]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[FauPhenol](
	[Id_PhnTyp] [int] NOT NULL,
	[ID_FFS] [int] NOT NULL,
 CONSTRAINT [PK_FAUPHENOL] PRIMARY KEY CLUSTERED 
(
	[Id_PhnTyp] ASC,
	[ID_FFS] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[EXPLAGRTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[EXPLAGRTYP](
	[Id_AgrTyp] [int] IDENTITY(0,1) NOT NULL,
	[CODE_AGRTYP] [char](6) NULL,
	[NOM_AGRTYP] [char](40) NULL,
	[EXPL_AGRTYP] [varchar](90) NULL,
 CONSTRAINT [PK_EXPLAGRTYP] PRIMARY KEY CLUSTERED 
(
	[Id_AgrTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[EtudesCompl_Concrn]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[EtudesCompl_Concrn](
	[Id_CsrnTyp] [int] NOT NULL,
	[Id_EtCpl] [int] NOT NULL,
 CONSTRAINT [PK_ETUDESCOMPL_CONCRN] PRIMARY KEY CLUSTERED 
(
	[Id_CsrnTyp] ASC,
	[Id_EtCpl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[EtudCompl_SourcesRef]    Script Date: 10/18/2012 12:45:19 ******/
CREATE TABLE [dbo].[EtudCompl_SourcesRef](
	[Id_Ref] [int] NOT NULL,
	[Id_EtCpl] [int] NOT NULL,
 CONSTRAINT [PK_ETUDCOMPL_SOURCESREF] PRIMARY KEY CLUSTERED 
(
	[Id_Ref] ASC,
	[Id_EtCpl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[ETUDCOMPL]    Script Date: 10/18/2012 12:45:19 ******/


CREATE TABLE [dbo].[ETUDCOMPL](
	[Id_EtCpl] [int] IDENTITY(0,1) NOT NULL,
	[Id_PlnGst] [int] NOT NULL,
	[CODE_ETUDE] [int] NULL,
	[THEME_ETCPL] [char](99) NULL,
	[BESSPE_ETCPL] [varchar](90) NULL,
	[METH_ETCPL] [varchar](90) NULL,
	[ECHCE_ETCPL] [date] NULL,
	[ACTR_ETCPL] [char](9) NULL,
	[COUT_ETCPL] [numeric](18, 0) NULL,
	[NOTE_ETCPL] [varchar](90) NULL,
 CONSTRAINT [PK_ETUDCOMPL] PRIMARY KEY CLUSTERED 
(
	[Id_EtCpl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[EspTypols]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[EspTypols](
	[Id_EspTypols] [int] IDENTITY(0,1) NOT NULL,
	[Code_EspTypols] [char](2) NULL,
	[Nom_EspTypols] [char](30) NULL,
	[Expl_EspTypols] [varchar](90) NULL,
 CONSTRAINT [PK_ESPTYPOLS] PRIMARY KEY CLUSTERED 
(
	[Id_EspTypols] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[EspaceTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[EspaceTyp](
	[Id_EspTyp] [int] IDENTITY(0,1) NOT NULL,
	[Id_EspTypols] [int] NOT NULL,
	[ID_Niveau] [int] NULL,
	[Code_EspTyp] [char](15) NULL,
	[Cod1_EspTyp] [char](3) NULL,
	[Cod2_EspTyp] [char](3) NULL,
	[Cod3_EspTyp] [char](3) NULL,
	[Niv_EspTyp] [numeric](1, 0) NULL,
	[Nom_EspTyp] [char](50) NULL,
	[Expl_EspTyp] [varchar](90) NULL,
 CONSTRAINT [PK_ESPACETYP] PRIMARY KEY CLUSTERED 
(
	[Id_EspTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[EQUIPEMENTSITE]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[EQUIPEMENTSITE](
	[Id_EqP] [int] IDENTITY(0,1) NOT NULL,
	[Id_TypEq] [int] NOT NULL,
	[ID_Sit] [int] NULL,
	[NOMEQ_EQP] [char](50) NULL,
	[LOCAL_EQP] [char](99) NULL,
	[DATE_EQP] [date] NULL,
	[EXPLIC_EQP] [varchar](90) NULL,
	[SIGID] [varchar](20) NULL,
 CONSTRAINT [PK_EQUIPEMENTSITE3] PRIMARY KEY CLUSTERED 
(
	[Id_EqP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[EquipCateg]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[EquipCateg](
	[Id_EquipCateg] [int] IDENTITY(0,1) NOT NULL,
	[Cod_EquipCateg] [char](6) NULL,
	[Nom_EquipCateg] [varchar](90) NULL,
	[Exp_EquipCateg] [varchar](90) NULL,
 CONSTRAINT [PK_EQUIPCATEG] PRIMARY KEY CLUSTERED 
(
	[Id_EquipCateg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ENDSTATTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ENDSTATTYP](
	[Id_EndTyp] [int] IDENTITY(0,1) NOT NULL,
	[Code_EndTyp] [char](2) NULL,
	[Nom_EndTyp] [char](50) NULL,
	[Exp_EndTyp] [varchar](90) NULL,
 CONSTRAINT [PK_ENDSTATTYP] PRIMARY KEY CLUSTERED 
(
	[Id_EndTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[DYSFONTYPES]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[DYSFONTYPES](
	[Id_TypDys] [int] IDENTITY(0,1) NOT NULL,
	[ID_Niveau] [int] NULL,
	[CODE_TYPDYS] [char](9) NULL,
	[COD1_TYPDYS] [char](3) NULL,
	[COD2_TYPDYS] [char](3) NULL,
	[Niv_TYPDYS] [numeric](1, 0) NULL,
	[NOM_TYPDYS] [char](30) NULL,
	[EXPLIC_TYPDYS] [char](99) NULL,
 CONSTRAINT [PK_DYSFONTYPES] PRIMARY KEY CLUSTERED 
(
	[Id_TypDys] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[DYSFONSITES]    Script Date: 10/18/2012 12:45:19 ******/

CREATE TABLE [dbo].[DYSFONSITES](
	[Id_Dys] [int] IDENTITY(0,1) NOT NULL,
	[Id_TypDys] [int] NULL,
	[ID_Sit] [int] NULL,
	[Nom_Dys] [char](50) NULL,
	[Cibl_Dys] [char](99) NULL,
	[Local_Dys] [char](255) NULL,
	[Date_Dys] [char](5) NULL,
	[Descr_Dys] [char](255) NULL,
 CONSTRAINT [PK_DYSFONSITES] PRIMARY KEY CLUSTERED 
(
	[Id_Dys] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[DysfonSite_ActivHumSit]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[DysfonSite_ActivHumSit](
	[Id_Dys] [int] IDENTITY(0,1) NOT NULL,
	[Id_Activ] [int] NOT NULL,
	[Explic_SrceIS] [varchar](90) NULL,
 CONSTRAINT [PK_DYSFONSITE_ACTIVHUMSIT] PRIMARY KEY CLUSTERED 
(
	[Id_Dys] ASC,
	[Id_Activ] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[DomaineConcerne]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[DomaineConcerne](
	[ID_CsrnCateg] [int] NOT NULL,
	[Id_CsrnDom] [int] NOT NULL,
 CONSTRAINT [PK_DOMAINECONCERNE] PRIMARY KEY CLUSTERED 
(
	[ID_CsrnCateg] ASC,
	[Id_CsrnDom] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[DIAGTHEMTYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[DIAGTHEMTYP](
	[Id_ThemT] [int] IDENTITY(0,1) NOT NULL,
	[Code_ThemT] [int] NULL,
	[Nom_ThemT] [char](50) NULL,
	[Desc_ThemT] [char](99) NULL,
 CONSTRAINT [PK_DIAGTHEMTYP] PRIMARY KEY CLUSTERED 
(
	[Id_ThemT] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[DIAGNOTHEM]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[DIAGNOTHEM](
	[Id_DiagT] [int] IDENTITY(0,1) NOT NULL,
	[Id_ThemT] [int] NOT NULL,
	[Id_DiagS] [int] NOT NULL,
	[Nom_DiagT] [char](40) NULL,
	[Theme_DiagT] [char](30) NULL,
	[Desc_DiagT] [char](99) NULL,
	[Autr_DiagT] [char](99) NULL,
 CONSTRAINT [PK_DIAGNOTHEM] PRIMARY KEY CLUSTERED 
(
	[Id_DiagT] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[DiagnoSite]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[DiagnoSite](
	[Id_DiagS] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[Intitule_DiagS] [char](90) NULL,
	[Date_DiagS] [date] NULL,
	[Cadre_DiagS] [char](99) NULL,
	[Fincmt_DiagS] [char](50) NULL,
 CONSTRAINT [PK_DIAGNOSITE] PRIMARY KEY CLUSTERED 
(
	[Id_DiagS] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[DeConcerneType]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[DeConcerneType](
	[Id_CsrnTyp] [int] NOT NULL,
	[Id_rgl] [int] NOT NULL,
 CONSTRAINT [PK_DECONCERNETYPE] PRIMARY KEY CLUSTERED 
(
	[Id_CsrnTyp] ASC,
	[Id_rgl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[ConcernTyp]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ConcernTyp](
	[Id_CsrnTyp] [int] IDENTITY(0,1) NOT NULL,
	[ID_CsrnCateg] [int] NULL,
	[ID_Niveau] [int] NULL,
	[COD_CsrnTyp] [char](6) NULL,
	[COD1_CsrnTyp] [char](6) NULL,
	[COD2_CsrnTyp] [char](6) NULL,
	[COD3_CsrnTyp] [char](6) NULL,
	[Cod4_CsrnTyp] [char](6) NULL,
	[Cod5_CsrnTyp] [char](6) NULL,
	[Niv_CsrnTyp] [numeric](1, 0) NULL,
	[NOM_CsrnTyp] [char](15) NULL,
	[ABREV_CsrnTyp] [char](10) NULL,
	[EXPL_CsrnTyp] [varchar](90) NULL,
 CONSTRAINT [PK_CONCERNTYP] PRIMARY KEY CLUSTERED 
(
	[Id_CsrnTyp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ConcernDom]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ConcernDom](
	[Id_CsrnDom] [int] IDENTITY(0,1) NOT NULL,
	[Cod_CsrnDom] [char](6) NULL,
	[Nom_CsrnDom] [varchar](90) NULL,
	[Exp_CsrnDom] [varchar](90) NULL,
 CONSTRAINT [PK_CONCERNDOM] PRIMARY KEY CLUSTERED 
(
	[Id_CsrnDom] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ConcernCateg]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ConcernCateg](
	[ID_CsrnCateg] [int] IDENTITY(0,1) NOT NULL,
	[COD_CSRNDOM4] [char](6) NOT NULL,
	[Nom_CsrnCateg] [varchar](90) NULL,
	[Exp_CsrnCateg] [varchar](90) NULL,
 CONSTRAINT [PK_CONCERNCATEG] PRIMARY KEY CLUSTERED 
(
	[ID_CsrnCateg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[CONCERNASS]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[CONCERNASS](
	[Id_Ass] [int] IDENTITY(0,1) NOT NULL,
	[Id_CsrnTyp] [int] NOT NULL,
	[DATCREAT_ASS] [date] NULL,
	[AUTOR_ASS] [char](8) NULL,
	[ADHTS_ASS] [numeric](6, 0) NULL,
	[DatAdht_Ass] [date] NULL,
	[STAT_ASS] [binary](1) NULL,
	[NOTES_ASS] [char](99) NULL,
 CONSTRAINT [PK_CONCERNASS] PRIMARY KEY CLUSTERED 
(
	[Id_Ass] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ClimSite_StatMeteo]    Script Date: 10/18/2012 12:45:19 ******/




CREATE TABLE [dbo].[ClimSite_StatMeteo](
	[Id_ClimSite] [int] NOT NULL,
	[Id_Met] [int] NOT NULL,
	[Dist_ClimSite_StatMeteo] [numeric](18, 0) NULL,
 CONSTRAINT [PK_CLIMSITE_STATMETEO] PRIMARY KEY CLUSTERED 
(
	[Id_ClimSite] ASC,
	[Id_Met] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[CLIMSITE]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[CLIMSITE](
	[Id_ClimSite] [int] IDENTITY(0,1) NOT NULL,
	[ID_Sit] [int] NULL,
	[DESCRP_CLIMG] [varchar](90) NULL,
	[DESCRT_CLIMG] [varchar](90) NULL,
	[DESCRB_CLIMG] [varchar](90) NULL,
	[DESCRG_CLIMG] [varchar](90) NULL,
	[DESCRV_CLIMG] [varchar](90) NULL,
 CONSTRAINT [PK_CLIMSITE] PRIMARY KEY CLUSTERED 
(
	[Id_ClimSite] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[ClassifAge]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[ClassifAge](
	[Id_ClassifAge] [int] IDENTITY(0,1) NOT NULL,
	[Code_ClassifAge] [char](6) NULL,
	[Nom_ClassifAge] [char](40) NULL,
	[Expl_ClassifAge] [varchar](90) NULL,
 CONSTRAINT [PK_CLASSIFAGE] PRIMARY KEY CLUSTERED 
(
	[Id_ClassifAge] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]



/****** Object:  Table [dbo].[CLASAGETYP]    Script Date: 10/18/2012 12:45:19 ******/






CREATE TABLE [dbo].[CLASAGETYP](
	[Id_ClAge] [int] IDENTITY(0,1) NOT NULL,
	[Id_ClassifAge] [int] NULL,
	[CODE_CLAGE] [char](6) NULL,
	[NOM_CLAGE] [char](40) NULL,
	[EXPL_CLAGE] [varchar](90) NULL,
 CONSTRAINT [PK_CLASAGETYP] PRIMARY KEY CLUSTERED 
(
	[Id_ClAge] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


/****** Object:  Default [DF__Region__SIGID__74794A9]    Script Date: 10/18/2012 12:45:19 ******/
ALTER TABLE [dbo].[Region] ADD  DEFAULT (NULL) FOR [SIGID]

